﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="details.aspx.vb" Inherits="Assignment_2___Prototype.details" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        CssClass="table" DataSourceID="UserDetailsSqlDataSource1" Width="923px">
        <Columns>
            <asp:ImageField DataImageUrlField="UserImage" HeaderText="Profile Picture">
                <ControlStyle CssClass="userProfileImage" />
            </asp:ImageField>
            <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
            <asp:BoundField DataField="FirstName" HeaderText="FirstName" 
                SortExpression="FirstName" />
            <asp:BoundField DataField="LastName" HeaderText="LastName" 
                SortExpression="LastName" />
            <asp:BoundField DataField="DOB" HeaderText="DOB" SortExpression="DOB" />
            <asp:BoundField DataField="Address1" HeaderText="Address1" 
                SortExpression="Address1" />
            <asp:BoundField DataField="Address2" HeaderText="Address2" 
                SortExpression="Address2" />
            <asp:BoundField DataField="Town" HeaderText="Town" SortExpression="Town" />
            <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
            <asp:BoundField DataField="Postcode" HeaderText="Postcode" 
                SortExpression="Postcode" />
            <asp:BoundField DataField="TelNo" HeaderText="TelNo" SortExpression="TelNo" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="UserDetailsSqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:UserConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:UserConnectionString.ProviderName %>" 
        SelectCommand="SELECT [Title], [FirstName], [LastName], [DOB], [Address1], [Address2], [Town], [City], [Postcode], [TelNo], [UserImage] FROM [User] WHERE ([UserID] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Name="UserID" QueryStringField="UserID" 
                Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>
